﻿SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO

CREATE PROCEDURE [dbo].[bhp_ModRecordExtensions] 
AS
BEGIN

	EXEC sp_rename 'dbo.bht_GroupExtensions.Extension', 'RecordExtension', 'COLUMN'
	ALTER TABLE bht_GroupExtensions 
		ALTER COLUMN RecordExtension NVARCHAR(400) NULL
	ALTER TABLE bht_GroupExtensions 
		ADD GroupExtension NVARCHAR(400) NULL

END
GO
EXEC [bhp_ModRecordExtensions]
GO
DROP PROCEDURE [bhp_ModRecordExtensions]
GO
